import pandas as pd, numpy as np
import statsmodels.api as sm
import matplotlib.pyplot as plt
d=pd.read_excel(r'C:\Users\chumenliuxiang\Desktop\2023美赛赛题\删除百分比错误、猜题数据过少、单词长短问题.xlsx')
print(d)
for i in range(1,344):
    world = d.iloc[i:i+1,3]
    for j in world:
        if len(str(j))!=5:
            print(d.iloc[i:i+1, 3])
            d.drop(labels=i,axis=0)
f=pd.ExcelWriter("chulihoushuju.xlsx");
d.to_excel(f); f.close()

